package com.kc.business.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 基础指标统计相关
 */
public interface BizBasicIndicatorsMapper {
    /**
     * 查询指定日期用户数
     * @param date
     * @param dateType
     * @return
     */
    int getUserNumByDate(@Param("date") String date,@Param("dateType") int dateType);
    @Select("SELECT SUM(pay_money) AS orderMoney FROM `kc_goods_order` WHERE LEFT(create_time,10) = #{date}")
    String  getOrderMoneyByDate(@Param("date") String date);
}
